| SQLSTATE |
22012 |
| EXCEPTIONS |
<small><i>not set</i></small> |
| DATASOURCE |
celerantsql |
| VENDORERRORCODE |
8134 |
| SQL |
SELECT a.styles_web_taxonomy_id,max(a.style_id) as style_id,max(a.style) as style,max(a.web_style) as web_style,max(a.description) as web_desc,max(a.web_desc) as web_description,max(a.web_long_desc) as web_long_desc,max(a.picture_id) as picture_id,max(a.sort_position) as prod_sort_position,max(a.dept) as dept,max(a.typ) as typ,max(a.subtyp_1) as subtyp_1,max(a.subtyp_2) as subtyp_2,max(a.subtyp_3) as subtyp_3,max(a.category_style) as category_style,max(a.web_url) as web_url,max(a.sort_position) as sort_position,max(a.web_taxonomy_id) as web_taxonomy_id,max(a.brand) as brand,max(a.date_entered) as date_entered,max(a.non_invt) as non_invt,max(a.overnight_required) as overnight_required,max(a.is_firearm) as is_firearm,max(a.of1) as of1,max(a.of2) as of2,max(a.of3) as of3,max(a.of4) as of4,max(a.of5) as of5,max(a.of6) as of6,max(a.of7) as of7,max(a.of8) as of8,max(a.of9) as of9,max(a.of10) as of10,max(a.of11) as of11,max(a.of12) as of12,max(a.of13) as of13,max(a.of14) as of14,max(a.of15) as of15,max(a.of16) as of16,max(a.of17) as of17,max(a.of18) as of18,max(a.of19) as of19,max(a.of20) as of20
,min(c.price) as min_price,min(c.store_price) as store_price,max(c.sugg_price) as max_price,min(c.wholesale_price) as vipprice,max(c.qoh) as qoh,max(c.qc) as qc,max(c.qs) as qs,sum(qoh + qc) as available,sum(c.qs - c.qc) as sold,max(c.sugg_price) AS max_sugg_price,avg(c.price / qq.of9) as round
FROM web_all_products a WITH (NOLOCK)
INNER JOIN dbo.tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
INNER JOIN dbo.tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
INNER JOIN dbo.tb_styles_web_taxonomy d WITH (NOLOCK) ON (a.style_id = d.style)
INNER JOIN dbo.tb_styles qq WITH (NOLOCK) ON (qq.style_id = a.style_id)
WHERE a.style_id > 0 and (a.of20='SPORTS' or a.of20='BOTH' or a.of20 = 'SPORTSOUTDOORS') and a.picture_id > 0
and qq.web_product='Y' and qq.status_finish <> 'Y' and c.store_id=10
and (a.style_id in (1355,12719,19180,23383,23390,23392,23549,23551,24387,24392,24660,39100,40129,42344,44618,44707,46420,48794,48828,48860,48885,48887,49987,50221,50264,50325,50330,50459,53933,61294,64138,72158,74223,74993,75668,76136,79544,84992,85328,93752,99098,109828,114206,116780,117784,121796,123330,131888,132756,134428,138138,147232,148591,150831,158185,161638,162540,163533,164646,168188,168679,168822,168824,169719,169726,172668,176233,179954,181985,183762,184364,185593,188437,189105,189112,189771,189782,192488,192947,195498,195523,197759,197836,198038,199531,199965,202716,203043,203384,203445,203618,204020,204254,204586,204620,205647,205649,208264,208893,209200,210661,210663,211004,211640,211940,215820,216779,216854,217249,217322,218051,218160,218326,218558,222329,223106,223131,227482,227643,228154,242351,244957,246100,246434,246702,247095,247136,247899,248199,248208,248699,248733,248908,249212,249478,249844,250171,250480,250950,251139,251573,253556,255317,255987,256128,256421,262010,262112,262114,262246,262480,262882,262948,263182,264086,264111,264477,264586,264913,266122,267126,267183,269091,269096,269823,270027,270066,270068,270863,272742,273310,273401,273467,273512,274001,274203,274444,275848,276050,276182,276852,276913,277379,277879,277988,277990,278324,278590,278592,278617,278883,279060,279115,280553,280594,281559,282995,283561,284029,285308,285801,286012,287516,287539,287684,288884,288945,289018,289820,289881,289947,290088,291160,291324,291626,291826,291987,291992,293132,293221,294625,294925,295002,296572,296799,296901,297533,297542,297935,297942,298405,299439,300584,300675,301084,301109,301243,301245,301488,301545,301647,301979,302011,302047,302054,302122,302190,302213,302247,302447,302513,302522,302549,302558,302781,302822,302824,302922,303049,303083,303451,304694,304953,305055,305062,305466,305496,305498,305657,306666,306668,306691,306693,306995,307025,307193,307270,307906,308138,309699,310444,310501,310839,311905,312214,312216,316496,319797,319902,320095,320097,320638,321306,321308,323203,323314,323339,323507,323512,323573,323680,325311,325379,325877,326081,326088,326181,326188,326286,326624,326822,326847,326858,328553,1327,4636,21898,21984,23388,24273,24324,24455,34533,35151,39332,40132,44629,44912,48655,48792,48923,50242,50245,50327,61810,61991,61992,69211,71052,72688,72706,75496,77853,77968,80044,86559,86560,86577,86578,87327,105744,106365,107584,110828,111160,121523,121524,122241,124914,125435,125599,136213,136382,137064,137599,144451,152893,158874,161632,163336,163822,164607,168302,168752,168819,168820,168834,173617,178597,179265,181920,183759,183795,183860,189776,190076,191312,193338,193837,194355,195559,196296,198450,200053,201608,202512,203515,203833,204534,204584,204701,204702,205655,205887,206106,206320,207324,208009,208727,209114,210167,211300,212089,212604,216966,216969,217170,217251,217252,217302,217370,217752,217905,218237,219774,220577,221999,222467,222768,222885,227244,227812,228147,231773,231823,231824,232209,232241,232291,245845,246700,247017,247218,247468,247518,247986,249040,249308,249321,249890,250057,250075,250461,251461,251462,253266,253369,253519,253969,253970,254187,256074,256159,257010,257195,257210,260553,261040,261658,261975,262143,262157,262158,262276,262394,264633,266806,266870,269095,270031,270613,270967,271014,272735,272753,272954,274643,275679,275980,276816,276947,277784,278069,278084,278252,278937,279156,281495,283200,283968,284200,286289,286857,287025,287379,287543,287544,287680,288498,288948,289098,289116,289233,289566,289819,291505,291555,291988,291991,292373,292474,292774,293192,296535,296918,296921,296922,297221,297286,297522,297907,298375,298407,298540,298894,300547,300579,300598,300712,301083,301165,301483,301784,301816,302001,302184,302219,302570,302784,302801,302819,303155,303620,303688,304223,304224,304323,304823,304974,304977,305009,305059,305509,305510,305545,306713,306714,306881,306882,306981,306982,306996,308253,310757,311093,311094,311243,311562,311711,311776,312062,312211,312212,312361,320067,321303,322307,322322,322440,322558,322625,323057,323394,323493,323508,323643,323725,323794,323979,324012,324061,324380,324730,325380,325383,326084,326134,326283,326651,326952,4644,6316,10913,12715,19033,19065,19067,19084,23377,23379,23547,24315,24332,24447,24449,24747,28291,28308,28310,32286,34477,41895,42329,44652,44705,44754,48866,50219,50236,50319,53929,53961,63789,70309,72247,73464,74487,74704,74855,75323,85213,85564,86668,87653,92767,104299,104301,105569,110017,114261,114644,118073,121981,122149,126376,128633,129286,130190,133815,134634,147502,147504,148857,149008,150827,151846,152548,161338,161342,162542,162544,164848,165001,168060,168309,168826,169815,170532,175980,179675,181143,188446,188448,189786,189903,192426,192994,196070,198559,198742,199593,200048,201633,201784,202503,202518,202671,202869,203892,204392,204458,205560,205613,206111,207415,213518,214586,216290,217041,217177,217977,218045,218047,218598,219800,219802,220136,221153,225431,225667,225950,226050,227286,227471,228141,228173,228207,231800,232185,246555,247210,247491,247525,248329,248846,248946,249899,250048,251571,251722,251756,252071,254162,256268,256285,256887,257087,257204,260595,260614,260744,260746,261882,262118,262148,262450,262599,262735,263386,263388,263620,264088,264154,264156,264688,264741,264839,267430,267496,269270,269402,269451,269936,270023,270070,270072,271174,271776,273263,273465,273499,276788,277073,277992,278228,278611,278730,278879,279549,282204,283976,284310,286584,286665,286750,287120,287186,287369,287401,287403,287452,287518,287552,288437,288905,288975,289090,289241,289726,289977,290009,290092,292215,292217,292247,292481,292634,292751,293568,294857,296108,296110,296429,296593,296878,296880,297063,297512,297514,297529,297563,298314,298416,298584,299116,299133,300520,301107,301543,301609,302194,302226,302243,302509,302526,302828,303047,303111,303262,303330,303364,303447,303613,303615,304230,304300,304317,304549,305049,305051,305485,305502,306670,306672,306687,306689,306704,306787,306887,307191,307272,307591,307659,307810,307908,309697,309946,310699,310833,310835,311169,311182,311333,311350,311903,311986,311988,312137,312222,312356,316632,316783,318923,320023,320059,320710,321263,321297,321310,321312,322350,322433,322567,322714,323001,323201,323233,323316,324054,324437,324739,325288,325322,325875,326124,326126,326277,326343,326643,326809,328296,11827,12713,19104,19872,23384,23391,24270,24302,24384,24663,24727,27971,34505,41300,42286,44665,44708,44758,44908,48802,48820,48945,50317,50324,50331,53918,61113,61377,65289,66543,87024,92765,108230,118076,120784,121166,121995,122063,122481,124878,126525,128522,143655,144873,150414,150675,156373,161335,164654,164911,168680,168816,172485,172949,176261,179687,179994,183620,184167,186732,189122,189129,189765,189779,189915,192948,193255,193859,195456,196824,199850,200461,201111,201636,201640,202158,202783,203887,204705,205230,205959,207202,209117,209199,209767,210664,211307,213511,214265,214926,215694,216269,216569,216705,216898,218048,218591,220749,222964,225904,227233,227458,227744,227801,228144,246117,246217,246710,247021,247521,248407,249000,249050,249311,249343,249454,249479,249897,250047,250479,250779,251533,254141,254216,256763,257038,257124,257199,257281,260557,260693,261225,261518,261947,262011,262111,262286,262590,262879,262947,263008,263183,263397,263801,263876,264083,264176,264694,266123,266834,266941,267159,267495,268177,268874,269088,269992,271453,272514,273250,273500,273861,274204,274504,276787,276819,276862,276969,277330,277880,278148,278323,278473,278541,278723,279152,280745,281031,281849,286697,287397,287422,287522,287547,288583,289094,289719,289723,290087,290123,291227,291252,291366,292002,292213,292477,292495,292706,293567,296107,296589,296757,296789,296889,296907,297182,297525,297561,297936,297986,299397,300519,300569,300883,301637,301973,301980,302048,302055,302337,302480,302498,302773,303048,303298,303302,304002,304220,304227,304802,305006,305474,305499,305538,305549,306674,306710,306785,306853,306985,307028,307192,309357,309482,309700,310025,310154,310279,310443,311240,311347,311604,311958,311990,312215,316420,316434,316459,316463,316495,319903,320096,320228,320707,322325,322429,322479,323286,323290,323322,323340,323404,323515,323729,323822,324015,324058,324476,324733,325301,325994,326005,326187,326337,2244,12675,13512,19042,19224,23385,23389,23539,24690,28051,31842,36608,44677,46450,48875,50244,50326,50329,53919,61376,61943,67023,69632,71036,74711,75180,75311,78405,85475,99497,100230,100283,113766,115488,118363,121790,122022,122057,123161,124548,126337,127973,130363,133172,133339,137515,138069,138588,143367,144635,145622,148580,158307,161216,161347,161934,163720,163924,164641,164642,168317,168753,168754,168817,168818,168835,168836,168968,169803,169807,173297,179999,181154,181921,183743,183761,189123,189124,189709,189759,189760,189778,191231,193221,193604,195476,195975,198816,199087,200019,200055,200056,202510,202913,203613,203917,204031,204264,204585,205921,206272,206321,206421,209448,209497,209579,209580,210166,210201,210665,212823,213442,215063,215163,215164,215181,215614,215946,217903,218021,219775,224187,225909,225959,225991,227481,227545,228150,232629,245411,246215,247015,247016,247219,247469,248369,249037,249488,249692,249873,250692,250777,250778,251295,251464,251778,252299,252550,253986,255421,256544,256943,257194,257212,257226,257280,257294,260552,261538,261605,262009,262123,262141,262142,262156,262159,262160,262591,263196,263864,264013,264082,264563,264964,264967,266054,266871,269093,269962,270065,270865,272755,273438,274642,276181,276813,276832,276863,277331,277785,278000,278003,278254,278268,278471,278535,278735,279925,280025,280276,280493,281011,281026,281594,281847,282030,282947,283201,286677,287192,287378,287495,287527,287528,287546,287877,288445,288582,288882,288914,289082,289114,289232,289818,289999,290085,290468,291253,291471,291554,291989,291990,292475,292707,292708,292757,292775,293412,293461,294916,296501,296502,296702,297219,297220,297288,297523,297588,297755,297788,297941,298342,298374,299127,300496,300713,300881,300913,301499,301500,301668,301735,301785,301817,301818,301850,301868,302185,302218,302504,302518,302585,302604,302768,302921,303603,304222,304225,304757,304975,304976,305044,305161,305475,305476,305511,305544,306665,307584,308219,309556,309837,310155,310156,310441,310791,310842,311242,311341,311427,312213,316690,319901,321302,321305,322438,322623,323341,323342,323642,323645,323695,323727,323809,324059,324778,324781,325296,325381,325382,326132,326635,6319,12671,19053,19089,28288,28313,36610,39150,42285,44732,44757,44759,44768,48837,48946,50314,50316,53949,53960,64020,70529,72333,73378,74648,74680,75350,79655,94027,101924,104298,113186,115351,115358,118963,120940,132297,134612,136845,137552,138322,141296,144874,147214,148141,150079,152553,152862,153257,156372,161343,161352,161981,162081,168833,169642,169808,170101,170367,170576,170646,172484,173050,175615,179997,181810,182503,185620,188921,189189,189598,189721,191395,193472,193867,195880,199083,200049,200328,200558,202666,202998,203000,203893,203895,204029,204438,206778,207244,207937,209486,210681,214121,215091,215300,216268,217040,217165,217508,217906,217965,218442,219803,219871,224185,225430,225853,225923,227302,227466,227800,245607,245811,246720,246777,246779,247013,247020,247322,247983,248147,248483,248892,248994,249292,249451,249485,249953,250062,250096,250128,250498,251457,251459,251534,251757,251902,252066,252227,253395,253665,253738,254142,256448,257207,257214,257273,257275,260556,260592,261517,261885,262119,262155,262487,262689,262787,263091,263257,263398,264102,264627,266442,266940,266942,267033,267142,268873,270018,270116,270141,271454,272149,272181,272756,273317,273860,276927,276961,277027,278472,278474,278533,278542,279267,280403,281341,281848,282386,282545,282550,282911,283411,283413,285285,285851,285985,285987,286287,286753,286887,287400,287657,287689,287866,288434,288436,289295,290906,291176,291812,292012,292278,292705,292871,293282,293450,294918,295109,296224,296279,296581,296590,296647,296790,296792,296881,296924,297183,297285,297290,297517,297519,297794,298396,299330,300568,300725,300870,301104,301238,301436,301463,301495,301497,301636,301736,302195,302340,302497,302508,302663,302672,302806,303365,303367,303408,303608,303610,304035,304803,304971,305003,305005,305046,305480,305482,305505,305507,306675,306677,306886,306984,307009,307277,309483,309785,310153,311591,311991,312225,318918,319813,319954,320622,320624,323287,323555,323587,323730,324057,324598,324625,324627,325300,325902,326129,326131,326138,326206,326261,326295,326304,326306,326329,326638,326833,4705,17602,19056,19063,19181,21978,23382,23550,24243,24275,24654,24704,24736,34532,39351,44617,44706,44756,44760,44767,44774,44924,48818,48829,50315,53934,53948,53952,54209,61129,61293,61804,61929,64137,65991,70403,72107,74683,74708,74715,74926,75051,79377,81885,86447,93892,99083,100905,101487,113580,116781,120350,120925,125355,131889,133561,134636,136190,137687,141249,144450,147222,150680,152488,154753,156357,158186,158504,161144,161337,163627,164627,164913,168128,168821,168832,170368,172483,173426,173619,175652,179435,180053,185601,188445,189102,189113,189445,189620,189756,189774,191503,192164,193668,195654,198319,199005,202424,202517,202781,202856,203617,204021,204028,204210,204703,205614,206075,206586,207954,208383,209115,210662,215017,215085,215299,215810,218050,219804,220447,221051,222537,227192,227474,227642,227717,227810,232222,245608,245844,247019,247523,248366,249034,249045,249066,249309,249495,249534,249570,249613,249620,249845,249877,251024,251106,251567,251574,252253,252485,252546,253021,253028,253446,253589,253746,253832,254000,256161,257208,257290,260691,260927,261713,261945,262145,262513,262949,263038,263785,264110,264153,264853,266407,266750,267093,268172,268947,269090,270069,270126,271966,272666,272748,273316,273595,275749,276796,276817,276846,277028,277989,277996,278239,278600,278875,281558,281640,282994,283437,286881,286888,287399,287492,287506,287867,288910,289103,289896,290089,291175,291257,291675,291943,291993,292218,292347,292479,293354,294633,294676,294751,294919,295087,296280,296316,296355,297184,297291,297477,297527,297541,298195,298288,300692,300928,301485,301610,301821,301846,301953,302189,302196,302221,302800,302807,303300,303600,303618,303961,304000,304229,304804,305040,305483,305497,305504,306669,306676,306683,306833,306983,306994,307019,307151,307194,307269,309734,310413,310745,310788,311181,311281,311349,311549,311992,312017,312206,312217,312224,312299,316429,316661,319630,319812,319955,320069,320094,321141,321309,322427,322502,322588,322638,322713,323206,323288,323356,323556,323981,324017,324056,324842,325903,326139,326171,326178,326246,326303,326321,326328,1333,19102,19283,21976,23378,23380,23410,24701,28292,28294,31836,31919,34461,35061,40594,42366,44653,44655,44753,48831,48880,50220,50237,50318,53930,55702,61435,67732,70172,74718,91798,99101,100239,102277,104300,104468,105153,108997,110901,113775,114645,115349,115749,117923,121165,121650,122816,122884,124790,135771,136939,145597,148856,150141,150577,150596,150679,150696,150828,161341,163715,164832,164915,164917,168578,168693,168695,168795,168827,168829,169095,169812,169814,170363,172052,172271,173341,181144,181812,181948,182433,184154,188815,189753,189766,189768,189770,194146,195599,199109,199530,200045,200047,202302,202502,202668,202670,203136,203170,203321,203838,203891,204025,204191,204208,204774,206078,208201,208771,208854,209122,210309,210660,210677,212813,215223,216289,216708,217042,217044,217242,217978,217980,218010,219799,219801,221152,221154,221156,225432,225951,227470,227472,227487,231799,231801,244952,245437,245654,247441,247760,248528,249047,249213,251570,251572,251721,251953,253425,254144,254161,254378,255699,257118,257188,257288,260596,260747,260764,262117,262151,262168,262183,262568,262785,262883,263034,263872,264023,264155,264474,264625,267031,268182,268703,268733,268767,269101,269303,270073,270856,273164,273466,273596,275753,276053,276791,276825,276923,277159,277359,277991,278061,278544,278580,281520,281954,282958,282975,283475,283560,283677,283892,284028,284111,286013,286498,286500,286751,287402,287451,287551,287785,288589,288974,289189,289559,289574,289944,289961,289976,290061,290091,291178,291180,292214,292282,293133,293384,294624,296611,296879,296930,296943,297064,297128,297181,297515,297528,297530,297715,297847,298566,298583,300570,300891,301106,301423,301425,301457,301489,301491,301542,301625,301708,301944,302061,302193,302242,302510,302576,302763,302793,302880,302912,303112,303263,303278,304231,304299,304801,304916,304984,305484,305503,306671,306673,306690,306973,307258,307273,307658,307907,309547,309696,309698,309732,309879,310398,310415,310500,310983,311102,311183,311904,311987,312019,312221,312387,316748,316784,318920,318924,319458,319773,319790,321294,321296,322447,322532,323319,323417,324019,324021,324738,325876,325993,326123,326127,326140,326293,326642,326644,326827) or a.style_id in (228179,175601,311586,296795,206090,280519,207038,294596,113771,164757,215222,75323,75310,75311,136213,283480,103481,75331,326190,284594,284592,207557,98896,284595,284593,75334))
and a.dept='Firearms'
group by a.styles_web_taxonomy_id |
|